package com.ourteam.product.ui.dao;

import java.util.Arrays;
import java.util.List;
import java.util.Map;
import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;
import org.apache.commons.lang.StringUtils;

/**
 * Template Name : DAO查询对象 Template Version : 1 Template Last Modfiy Date : Sat Aug 19 10:06:32 CST
 * 2017 Auto Generate Date : 2018-12-14 15:15:14 Warning ! This file will be overwrite when
 * regenerate !
 */
public class ProductUITreeNodeDAOQueryBean extends BaseQueryBean {

  public ProductUITreeNodeDAOQueryBean() {
    super();
  }

  public ProductUITreeNodeDAOQueryBean(BaseQueryBean aQueryBean) {
    super(aQueryBean);
  }

  public ProductUITreeNodeDAOQueryBean(BaseQueryBean aQueryBean, Map tableReplaceMap) {
    super(aQueryBean, tableReplaceMap);
  }

  public Criteria createCriteria() {

    Criteria criteria = createCriteriaInternal();
    if (oredCriteria.size() == 0) {
      oredCriteria.add(criteria);
    }
    return criteria;
  }

  protected Criteria createCriteriaInternal() {
    return new Criteria(this);
  }

  public void addIdSelectProperty() {
    addIdSelectProperty("id");
  }

  public void addIdSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.Id, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.Id, "id");
    }
  }

  public void addTreeIdSelectProperty() {
    addTreeIdSelectProperty("treeId");
  }

  public void addTreeIdSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.TreeId, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.TreeId, "treeId");
    }
  }

  public void addCodeSelectProperty() {
    addCodeSelectProperty("code");
  }

  public void addCodeSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.Code, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.Code, "code");
    }
  }

  public void addTitleSelectProperty() {
    addTitleSelectProperty("title");
  }

  public void addTitleSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.Title, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.Title, "title");
    }
  }

  public void addTitleKeySelectProperty() {
    addTitleKeySelectProperty("titleKey");
  }

  public void addTitleKeySelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.TitleKey, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.TitleKey, "titleKey");
    }
  }

  public void addIconSelectProperty() {
    addIconSelectProperty("icon");
  }

  public void addIconSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.Icon, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.Icon, "icon");
    }
  }

  public void addIsLeafSelectProperty() {
    addIsLeafSelectProperty("isLeaf");
  }

  public void addIsLeafSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.IsLeaf, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.IsLeaf, "isLeaf");
    }
  }

  public void addLastModifyUserSelectProperty() {
    addLastModifyUserSelectProperty("lastModifyUser");
  }

  public void addLastModifyUserSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.LastModifyUser, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.LastModifyUser, "lastModifyUser");
    }
  }

  public void addLastModifyTimeSelectProperty() {
    addLastModifyTimeSelectProperty("lastModifyTime");
  }

  public void addLastModifyTimeSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.LastModifyTime, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.LastModifyTime, "lastModifyTime");
    }
  }

  public void addStatusSelectProperty() {
    addStatusSelectProperty("status");
  }

  public void addStatusSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.Status, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.Status, "status");
    }
  }

  public void addRemarksSelectProperty() {
    addRemarksSelectProperty("remarks");
  }

  public void addRemarksSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.Remarks, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.Remarks, "remarks");
    }
  }

  public void addIsRootSelectProperty() {
    addIsRootSelectProperty("isRoot");
  }

  public void addIsRootSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProductUITreeNodeDAO.IsRoot, aAlias);
    } else {
      addSelectProperty(IProductUITreeNodeDAO.IsRoot, "isRoot");
    }
  }

  public void addAllSelectProperties() {

    addIdSelectProperty();

    addTreeIdSelectProperty();

    addCodeSelectProperty();

    addTitleSelectProperty();

    addTitleKeySelectProperty();

    addIconSelectProperty();

    addIsLeafSelectProperty();

    addLastModifyUserSelectProperty();

    addLastModifyTimeSelectProperty();

    addStatusSelectProperty();

    addRemarksSelectProperty();

    addIsRootSelectProperty();
  }

  public static class Criteria extends BaseWhereCriterion<ProductUITreeNodeDAOQueryBean> {

    protected Criteria(ProductUITreeNodeDAOQueryBean aParentObject) {
      super(aParentObject);
    }

    public Criteria andIdIsNull() {
      addCriterion(IProductUITreeNodeDAO.Id + " is null");
      return this;
    }

    public Criteria andIdIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.Id + " is not null");
      return this;
    }

    public Criteria andIdIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.Id + " is not null AND " + IProductUITreeNodeDAO.Id + " <> ''");
      return this;
    }

    public Criteria andIdIsEmpty() {
      addCriterion(
          "(" + IProductUITreeNodeDAO.Id + " is null OR " + IProductUITreeNodeDAO.Id + " = '')");
      return this;
    }

    public Criteria andIdEqualTo(long value) {
      return andIdEqualTo(Long.valueOf(value));
    }

    public Criteria andIdEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.Id + " = ", value, "id");
      return this;
    }

    public Criteria andIdEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Id);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Id + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdNotEqualTo(long value) {
      return andIdNotEqualTo(Long.valueOf(value));
    }

    public Criteria andIdNotEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.Id + " <>", value, "id");
      return this;
    }

    public Criteria andIdNotEqualToOrIsNull(long value) {
      return andIdNotEqualToOrIsNull(Long.valueOf(value));
    }

    public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {

      addCriterion(
          IProductUITreeNodeDAO.Id + " is null OR " + IProductUITreeNodeDAO.Id + " <>",
          value,
          "id");
      return this;
    }

    public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Id);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Id + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdGreaterThan(long value) {
      return andIdGreaterThan(Long.valueOf(value));
    }

    public Criteria andIdGreaterThan(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.Id + " >", value, "id");
      return this;
    }

    public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Id);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdGreaterThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Id + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdGreaterThanOrEqualTo(long value) {
      return andIdGreaterThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.Id + " >=", value, "id");
      return this;
    }

    public Criteria andIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Id);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Id + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdLessThan(long value) {
      return andIdLessThan(Long.valueOf(value));
    }

    public Criteria andIdLessThan(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.Id + " <", value, "id");
      return this;
    }

    public Criteria andIdLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Id);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Id + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdLessThanOrEqualTo(long value) {
      return andIdLessThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.Id + " <=", value, "id");
      return this;
    }

    public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Id);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Id + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdIn(long[] values) {
      if (values.length == 1) {
        return andIdEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Id + " in", values, "id");
        return this;
      }
    }

    public Criteria andIdNotIn(long[] values) {
      if (values.length == 1) {
        return andIdNotEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Id + " not in", values, "id");
        return this;
      }
    }

    public Criteria andIdIn(List<java.lang.Long> values) {

      if (values.size() == 1) {
        return andIdEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Id + " in", values, "id");
        return this;
      }
    }

    public Criteria andIdNotIn(List<java.lang.Long> values) {
      if (values.size() == 1) {
        return andIdNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Id + " not in", values, "id");
        return this;
      }
    }

    public Criteria andIdIn(java.lang.Long[] values) {

      if (values.length == 1) {
        return andIdEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Id + " in", Arrays.asList(values), "id");
        return this;
      }
    }

    public Criteria andIdNotIn(java.lang.Long[] values) {
      if (values.length == 1) {
        return andIdNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Id + " not in", Arrays.asList(values), "id");
        return this;
      }
    }

    public Criteria andIdIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Id + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Id + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdBetween(long value1, long value2) {
      addCriterion(IProductUITreeNodeDAO.Id + " between", value1, value2, "id");
      return this;
    }

    public Criteria andIdBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeNodeDAO.Id + " between", value1, value2, "id");
      return this;
    }

    public Criteria andIdNotBetween(long value1, long value2) {
      addCriterion(IProductUITreeNodeDAO.Id + " not between", value1, value2, "id");
      return this;
    }

    public Criteria andIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeNodeDAO.Id + " not between", value1, value2, "id");
      return this;
    }

    public Criteria andTreeIdIsNull() {
      addCriterion(IProductUITreeNodeDAO.TreeId + " is null");
      return this;
    }

    public Criteria andTreeIdIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.TreeId + " is not null");
      return this;
    }

    public Criteria andTreeIdIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.TreeId
              + " is not null AND "
              + IProductUITreeNodeDAO.TreeId
              + " <> ''");
      return this;
    }

    public Criteria andTreeIdIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeNodeDAO.TreeId
              + " is null OR "
              + IProductUITreeNodeDAO.TreeId
              + " = '')");
      return this;
    }

    public Criteria andTreeIdEqualTo(long value) {
      return andTreeIdEqualTo(Long.valueOf(value));
    }

    public Criteria andTreeIdEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.TreeId + " = ", value, "treeId");
      return this;
    }

    public Criteria andTreeIdEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TreeId);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdNotEqualTo(long value) {
      return andTreeIdNotEqualTo(Long.valueOf(value));
    }

    public Criteria andTreeIdNotEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.TreeId + " <>", value, "treeId");
      return this;
    }

    public Criteria andTreeIdNotEqualToOrIsNull(long value) {
      return andTreeIdNotEqualToOrIsNull(Long.valueOf(value));
    }

    public Criteria andTreeIdNotEqualToOrIsNull(java.lang.Long value) {

      addCriterion(
          IProductUITreeNodeDAO.TreeId + " is null OR " + IProductUITreeNodeDAO.TreeId + " <>",
          value,
          "treeId");
      return this;
    }

    public Criteria andTreeIdNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TreeId);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdGreaterThan(long value) {
      return andTreeIdGreaterThan(Long.valueOf(value));
    }

    public Criteria andTreeIdGreaterThan(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.TreeId + " >", value, "treeId");
      return this;
    }

    public Criteria andTreeIdGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TreeId);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdGreaterThanOrEqualTo(long value) {
      return andTreeIdGreaterThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andTreeIdGreaterThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.TreeId + " >=", value, "treeId");
      return this;
    }

    public Criteria andTreeIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TreeId);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdLessThan(long value) {
      return andTreeIdLessThan(Long.valueOf(value));
    }

    public Criteria andTreeIdLessThan(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.TreeId + " <", value, "treeId");
      return this;
    }

    public Criteria andTreeIdLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TreeId);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdLessThanOrEqualTo(long value) {
      return andTreeIdLessThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andTreeIdLessThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProductUITreeNodeDAO.TreeId + " <=", value, "treeId");
      return this;
    }

    public Criteria andTreeIdLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TreeId);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTreeIdLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdIn(long[] values) {
      if (values.length == 1) {
        return andTreeIdEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.TreeId + " in", values, "treeId");
        return this;
      }
    }

    public Criteria andTreeIdNotIn(long[] values) {
      if (values.length == 1) {
        return andTreeIdNotEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.TreeId + " not in", values, "treeId");
        return this;
      }
    }

    public Criteria andTreeIdIn(List<java.lang.Long> values) {

      if (values.size() == 1) {
        return andTreeIdEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.TreeId + " in", values, "treeId");
        return this;
      }
    }

    public Criteria andTreeIdNotIn(List<java.lang.Long> values) {
      if (values.size() == 1) {
        return andTreeIdNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.TreeId + " not in", values, "treeId");
        return this;
      }
    }

    public Criteria andTreeIdIn(java.lang.Long[] values) {

      if (values.length == 1) {
        return andTreeIdEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.TreeId + " in", Arrays.asList(values), "treeId");
        return this;
      }
    }

    public Criteria andTreeIdNotIn(java.lang.Long[] values) {
      if (values.length == 1) {
        return andTreeIdNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.TreeId + " not in", Arrays.asList(values), "treeId");
        return this;
      }
    }

    public Criteria andTreeIdIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andTreeIdBetween(long value1, long value2) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " between", value1, value2, "treeId");
      return this;
    }

    public Criteria andTreeIdBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " between", value1, value2, "treeId");
      return this;
    }

    public Criteria andTreeIdNotBetween(long value1, long value2) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " not between", value1, value2, "treeId");
      return this;
    }

    public Criteria andTreeIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProductUITreeNodeDAO.TreeId + " not between", value1, value2, "treeId");
      return this;
    }

    public Criteria andCodeIsNull() {
      addCriterion(IProductUITreeNodeDAO.Code + " is null");
      return this;
    }

    public Criteria andCodeIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.Code + " is not null");
      return this;
    }

    public Criteria andCodeIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.Code + " is not null AND " + IProductUITreeNodeDAO.Code + " <> ''");
      return this;
    }

    public Criteria andCodeIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeNodeDAO.Code
              + " is null OR "
              + IProductUITreeNodeDAO.Code
              + " = '')");
      return this;
    }

    public Criteria andCodeEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Code + " = ", value, "code");
      return this;
    }

    public Criteria andCodeEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Code);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andCodeEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Code + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andCodeNotEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Code + " <>", value, "code");
      return this;
    }

    public Criteria andCodeNotEqualToOrIsNull(String value) {

      addCriterion(
          IProductUITreeNodeDAO.Code + " is null OR " + IProductUITreeNodeDAO.Code + " <>",
          value,
          "code");
      return this;
    }

    public Criteria andCodeNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Code);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andCodeNotEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Code + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andCodeGreaterThan(String value) {

      addCriterion(IProductUITreeNodeDAO.Code + " >", value, "code");
      return this;
    }

    public Criteria andCodeGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Code);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andCodeGreaterThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Code + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andCodeGreaterThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Code + " >=", value, "code");
      return this;
    }

    public Criteria andCodeGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Code);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andCodeGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Code + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andCodeLessThan(String value) {

      addCriterion(IProductUITreeNodeDAO.Code + " <", value, "code");
      return this;
    }

    public Criteria andCodeLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Code);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andCodeLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Code + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andCodeLessThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Code + " <=", value, "code");
      return this;
    }

    public Criteria andCodeLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Code);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andCodeLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Code + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andCodeLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.Code + " like", buffer.toString(), "code");
      return this;
    }

    public Criteria andCodeNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.Code + " not like", buffer.toString(), "code");
      return this;
    }

    public Criteria andCodeIn(List<String> values) {

      if (values.size() == 1) {
        return andCodeEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Code + " in", values, "code");
        return this;
      }
    }

    public Criteria andCodeNotIn(List<String> values) {
      if (values.size() == 1) {
        return andCodeNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Code + " not in", values, "code");
        return this;
      }
    }

    public Criteria andCodeIn(String[] values) {

      if (values.length == 1) {
        return andCodeEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Code + " in", Arrays.asList(values), "code");
        return this;
      }
    }

    public Criteria andCodeNotIn(String[] values) {
      if (values.length == 1) {
        return andCodeNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Code + " not in", Arrays.asList(values), "code");
        return this;
      }
    }

    public Criteria andCodeIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Code + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andCodeNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Code + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andCodeBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.Code + " between", value1, value2, "code");
      return this;
    }

    public Criteria andCodeNotBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.Code + " not between", value1, value2, "code");
      return this;
    }

    public Criteria andTitleIsNull() {
      addCriterion(IProductUITreeNodeDAO.Title + " is null");
      return this;
    }

    public Criteria andTitleIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.Title + " is not null");
      return this;
    }

    public Criteria andTitleIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.Title
              + " is not null AND "
              + IProductUITreeNodeDAO.Title
              + " <> ''");
      return this;
    }

    public Criteria andTitleIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeNodeDAO.Title
              + " is null OR "
              + IProductUITreeNodeDAO.Title
              + " = '')");
      return this;
    }

    public Criteria andTitleEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Title + " = ", value, "title");
      return this;
    }

    public Criteria andTitleEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Title);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Title + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleNotEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Title + " <>", value, "title");
      return this;
    }

    public Criteria andTitleNotEqualToOrIsNull(String value) {

      addCriterion(
          IProductUITreeNodeDAO.Title + " is null OR " + IProductUITreeNodeDAO.Title + " <>",
          value,
          "title");
      return this;
    }

    public Criteria andTitleNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Title);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleNotEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Title + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleGreaterThan(String value) {

      addCriterion(IProductUITreeNodeDAO.Title + " >", value, "title");
      return this;
    }

    public Criteria andTitleGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Title);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Title + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleGreaterThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Title + " >=", value, "title");
      return this;
    }

    public Criteria andTitleGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Title);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Title + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleLessThan(String value) {

      addCriterion(IProductUITreeNodeDAO.Title + " <", value, "title");
      return this;
    }

    public Criteria andTitleLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Title);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Title + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleLessThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Title + " <=", value, "title");
      return this;
    }

    public Criteria andTitleLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Title);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Title + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.Title + " like", buffer.toString(), "title");
      return this;
    }

    public Criteria andTitleNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.Title + " not like", buffer.toString(), "title");
      return this;
    }

    public Criteria andTitleIn(List<String> values) {

      if (values.size() == 1) {
        return andTitleEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Title + " in", values, "title");
        return this;
      }
    }

    public Criteria andTitleNotIn(List<String> values) {
      if (values.size() == 1) {
        return andTitleNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Title + " not in", values, "title");
        return this;
      }
    }

    public Criteria andTitleIn(String[] values) {

      if (values.length == 1) {
        return andTitleEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Title + " in", Arrays.asList(values), "title");
        return this;
      }
    }

    public Criteria andTitleNotIn(String[] values) {
      if (values.length == 1) {
        return andTitleNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Title + " not in", Arrays.asList(values), "title");
        return this;
      }
    }

    public Criteria andTitleIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Title + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Title + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.Title + " between", value1, value2, "title");
      return this;
    }

    public Criteria andTitleNotBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.Title + " not between", value1, value2, "title");
      return this;
    }

    public Criteria andTitleKeyIsNull() {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " is null");
      return this;
    }

    public Criteria andTitleKeyIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " is not null");
      return this;
    }

    public Criteria andTitleKeyIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.TitleKey
              + " is not null AND "
              + IProductUITreeNodeDAO.TitleKey
              + " <> ''");
      return this;
    }

    public Criteria andTitleKeyIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeNodeDAO.TitleKey
              + " is null OR "
              + IProductUITreeNodeDAO.TitleKey
              + " = '')");
      return this;
    }

    public Criteria andTitleKeyEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.TitleKey + " = ", value, "titleKey");
      return this;
    }

    public Criteria andTitleKeyEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TitleKey);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleKeyEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleKeyNotEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.TitleKey + " <>", value, "titleKey");
      return this;
    }

    public Criteria andTitleKeyNotEqualToOrIsNull(String value) {

      addCriterion(
          IProductUITreeNodeDAO.TitleKey + " is null OR " + IProductUITreeNodeDAO.TitleKey + " <>",
          value,
          "titleKey");
      return this;
    }

    public Criteria andTitleKeyNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TitleKey);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleKeyNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleKeyGreaterThan(String value) {

      addCriterion(IProductUITreeNodeDAO.TitleKey + " >", value, "titleKey");
      return this;
    }

    public Criteria andTitleKeyGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TitleKey);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleKeyGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleKeyGreaterThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.TitleKey + " >=", value, "titleKey");
      return this;
    }

    public Criteria andTitleKeyGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TitleKey);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleKeyGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleKeyLessThan(String value) {

      addCriterion(IProductUITreeNodeDAO.TitleKey + " <", value, "titleKey");
      return this;
    }

    public Criteria andTitleKeyLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TitleKey);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleKeyLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleKeyLessThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.TitleKey + " <=", value, "titleKey");
      return this;
    }

    public Criteria andTitleKeyLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.TitleKey);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andTitleKeyLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleKeyLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.TitleKey + " like", buffer.toString(), "titleKey");
      return this;
    }

    public Criteria andTitleKeyNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.TitleKey + " not like", buffer.toString(), "titleKey");
      return this;
    }

    public Criteria andTitleKeyIn(List<String> values) {

      if (values.size() == 1) {
        return andTitleKeyEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.TitleKey + " in", values, "titleKey");
        return this;
      }
    }

    public Criteria andTitleKeyNotIn(List<String> values) {
      if (values.size() == 1) {
        return andTitleKeyNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.TitleKey + " not in", values, "titleKey");
        return this;
      }
    }

    public Criteria andTitleKeyIn(String[] values) {

      if (values.length == 1) {
        return andTitleKeyEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.TitleKey + " in", Arrays.asList(values), "titleKey");
        return this;
      }
    }

    public Criteria andTitleKeyNotIn(String[] values) {
      if (values.length == 1) {
        return andTitleKeyNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.TitleKey + " not in", Arrays.asList(values), "titleKey");
        return this;
      }
    }

    public Criteria andTitleKeyIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleKeyNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andTitleKeyBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " between", value1, value2, "titleKey");
      return this;
    }

    public Criteria andTitleKeyNotBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.TitleKey + " not between", value1, value2, "titleKey");
      return this;
    }

    public Criteria andIconIsNull() {
      addCriterion(IProductUITreeNodeDAO.Icon + " is null");
      return this;
    }

    public Criteria andIconIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.Icon + " is not null");
      return this;
    }

    public Criteria andIconIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.Icon + " is not null AND " + IProductUITreeNodeDAO.Icon + " <> ''");
      return this;
    }

    public Criteria andIconIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeNodeDAO.Icon
              + " is null OR "
              + IProductUITreeNodeDAO.Icon
              + " = '')");
      return this;
    }

    public Criteria andIconEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Icon + " = ", value, "icon");
      return this;
    }

    public Criteria andIconEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Icon);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIconEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Icon + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andIconNotEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Icon + " <>", value, "icon");
      return this;
    }

    public Criteria andIconNotEqualToOrIsNull(String value) {

      addCriterion(
          IProductUITreeNodeDAO.Icon + " is null OR " + IProductUITreeNodeDAO.Icon + " <>",
          value,
          "icon");
      return this;
    }

    public Criteria andIconNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Icon);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIconNotEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Icon + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andIconGreaterThan(String value) {

      addCriterion(IProductUITreeNodeDAO.Icon + " >", value, "icon");
      return this;
    }

    public Criteria andIconGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Icon);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIconGreaterThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Icon + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andIconGreaterThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Icon + " >=", value, "icon");
      return this;
    }

    public Criteria andIconGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Icon);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIconGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Icon + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIconLessThan(String value) {

      addCriterion(IProductUITreeNodeDAO.Icon + " <", value, "icon");
      return this;
    }

    public Criteria andIconLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Icon);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIconLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Icon + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andIconLessThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Icon + " <=", value, "icon");
      return this;
    }

    public Criteria andIconLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Icon);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIconLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Icon + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIconLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.Icon + " like", buffer.toString(), "icon");
      return this;
    }

    public Criteria andIconNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.Icon + " not like", buffer.toString(), "icon");
      return this;
    }

    public Criteria andIconIn(List<String> values) {

      if (values.size() == 1) {
        return andIconEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Icon + " in", values, "icon");
        return this;
      }
    }

    public Criteria andIconNotIn(List<String> values) {
      if (values.size() == 1) {
        return andIconNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Icon + " not in", values, "icon");
        return this;
      }
    }

    public Criteria andIconIn(String[] values) {

      if (values.length == 1) {
        return andIconEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Icon + " in", Arrays.asList(values), "icon");
        return this;
      }
    }

    public Criteria andIconNotIn(String[] values) {
      if (values.length == 1) {
        return andIconNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Icon + " not in", Arrays.asList(values), "icon");
        return this;
      }
    }

    public Criteria andIconIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Icon + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIconNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Icon + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIconBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.Icon + " between", value1, value2, "icon");
      return this;
    }

    public Criteria andIconNotBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.Icon + " not between", value1, value2, "icon");
      return this;
    }

    public Criteria andIsLeafIsNull() {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " is null");
      return this;
    }

    public Criteria andIsLeafIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " is not null");
      return this;
    }

    public Criteria andIsLeafIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.IsLeaf
              + " is not null AND "
              + IProductUITreeNodeDAO.IsLeaf
              + " <> ''");
      return this;
    }

    public Criteria andIsLeafIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeNodeDAO.IsLeaf
              + " is null OR "
              + IProductUITreeNodeDAO.IsLeaf
              + " = '')");
      return this;
    }

    public Criteria andIsLeafEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.IsLeaf + " = ", value, "isLeaf");
      return this;
    }

    public Criteria andIsLeafEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsLeaf);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsLeafEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsLeafNotEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.IsLeaf + " <>", value, "isLeaf");
      return this;
    }

    public Criteria andIsLeafNotEqualToOrIsNull(String value) {

      addCriterion(
          IProductUITreeNodeDAO.IsLeaf + " is null OR " + IProductUITreeNodeDAO.IsLeaf + " <>",
          value,
          "isLeaf");
      return this;
    }

    public Criteria andIsLeafNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsLeaf);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsLeafNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsLeafGreaterThan(String value) {

      addCriterion(IProductUITreeNodeDAO.IsLeaf + " >", value, "isLeaf");
      return this;
    }

    public Criteria andIsLeafGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsLeaf);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsLeafGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsLeafGreaterThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.IsLeaf + " >=", value, "isLeaf");
      return this;
    }

    public Criteria andIsLeafGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsLeaf);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsLeafGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsLeafLessThan(String value) {

      addCriterion(IProductUITreeNodeDAO.IsLeaf + " <", value, "isLeaf");
      return this;
    }

    public Criteria andIsLeafLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsLeaf);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsLeafLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsLeafLessThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.IsLeaf + " <=", value, "isLeaf");
      return this;
    }

    public Criteria andIsLeafLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsLeaf);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsLeafLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsLeafLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " like", buffer.toString(), "isLeaf");
      return this;
    }

    public Criteria andIsLeafNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " not like", buffer.toString(), "isLeaf");
      return this;
    }

    public Criteria andIsLeafIn(List<String> values) {

      if (values.size() == 1) {
        return andIsLeafEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.IsLeaf + " in", values, "isLeaf");
        return this;
      }
    }

    public Criteria andIsLeafNotIn(List<String> values) {
      if (values.size() == 1) {
        return andIsLeafNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.IsLeaf + " not in", values, "isLeaf");
        return this;
      }
    }

    public Criteria andIsLeafIn(String[] values) {

      if (values.length == 1) {
        return andIsLeafEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.IsLeaf + " in", Arrays.asList(values), "isLeaf");
        return this;
      }
    }

    public Criteria andIsLeafNotIn(String[] values) {
      if (values.length == 1) {
        return andIsLeafNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.IsLeaf + " not in", Arrays.asList(values), "isLeaf");
        return this;
      }
    }

    public Criteria andIsLeafIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsLeafNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsLeafBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " between", value1, value2, "isLeaf");
      return this;
    }

    public Criteria andIsLeafNotBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.IsLeaf + " not between", value1, value2, "isLeaf");
      return this;
    }

    public Criteria andLastModifyUserIsNull() {
      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " is null");
      return this;
    }

    public Criteria andLastModifyUserIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " is not null");
      return this;
    }

    public Criteria andLastModifyUserIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.LastModifyUser
              + " is not null AND "
              + IProductUITreeNodeDAO.LastModifyUser
              + " <> ''");
      return this;
    }

    public Criteria andLastModifyUserIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeNodeDAO.LastModifyUser
              + " is null OR "
              + IProductUITreeNodeDAO.LastModifyUser
              + " = '')");
      return this;
    }

    public Criteria andLastModifyUserEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " = ", value, "lastModifyUser");
      return this;
    }

    public Criteria andLastModifyUserEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyUser);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyUserEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyUserNotEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " <>", value, "lastModifyUser");
      return this;
    }

    public Criteria andLastModifyUserNotEqualToOrIsNull(String value) {

      addCriterion(
          IProductUITreeNodeDAO.LastModifyUser
              + " is null OR "
              + IProductUITreeNodeDAO.LastModifyUser
              + " <>",
          value,
          "lastModifyUser");
      return this;
    }

    public Criteria andLastModifyUserNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyUser);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyUserNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyUserGreaterThan(String value) {

      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " >", value, "lastModifyUser");
      return this;
    }

    public Criteria andLastModifyUserGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyUser);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyUserGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyUserGreaterThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " >=", value, "lastModifyUser");
      return this;
    }

    public Criteria andLastModifyUserGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyUser);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyUserGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyUserLessThan(String value) {

      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " <", value, "lastModifyUser");
      return this;
    }

    public Criteria andLastModifyUserLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyUser);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyUserLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyUserLessThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " <=", value, "lastModifyUser");
      return this;
    }

    public Criteria andLastModifyUserLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyUser);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyUserLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyUserLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(
          IProductUITreeNodeDAO.LastModifyUser + " like", buffer.toString(), "lastModifyUser");
      return this;
    }

    public Criteria andLastModifyUserNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(
          IProductUITreeNodeDAO.LastModifyUser + " not like", buffer.toString(), "lastModifyUser");
      return this;
    }

    public Criteria andLastModifyUserIn(List<String> values) {

      if (values.size() == 1) {
        return andLastModifyUserEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.LastModifyUser + " in", values, "lastModifyUser");
        return this;
      }
    }

    public Criteria andLastModifyUserNotIn(List<String> values) {
      if (values.size() == 1) {
        return andLastModifyUserNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.LastModifyUser + " not in", values, "lastModifyUser");
        return this;
      }
    }

    public Criteria andLastModifyUserIn(String[] values) {

      if (values.length == 1) {
        return andLastModifyUserEqualTo(values[0]);
      } else {
        addCriterion(
            IProductUITreeNodeDAO.LastModifyUser + " in", Arrays.asList(values), "lastModifyUser");
        return this;
      }
    }

    public Criteria andLastModifyUserNotIn(String[] values) {
      if (values.length == 1) {
        return andLastModifyUserNotEqualTo(values[0]);
      } else {
        addCriterion(
            IProductUITreeNodeDAO.LastModifyUser + " not in",
            Arrays.asList(values),
            "lastModifyUser");
        return this;
      }
    }

    public Criteria andLastModifyUserIn(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyUserNotIn(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyUser + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyUserBetween(String value1, String value2) {
      addCriterion(
          IProductUITreeNodeDAO.LastModifyUser + " between", value1, value2, "lastModifyUser");
      return this;
    }

    public Criteria andLastModifyUserNotBetween(String value1, String value2) {
      addCriterion(
          IProductUITreeNodeDAO.LastModifyUser + " not between", value1, value2, "lastModifyUser");
      return this;
    }

    public Criteria andLastModifyTimeIsNull() {
      addCriterion(IProductUITreeNodeDAO.LastModifyTime + " is null");
      return this;
    }

    public Criteria andLastModifyTimeIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.LastModifyTime + " is not null");
      return this;
    }

    public Criteria andLastModifyTimeIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.LastModifyTime
              + " is not null AND "
              + IProductUITreeNodeDAO.LastModifyTime
              + " <> ''");
      return this;
    }

    public Criteria andLastModifyTimeIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeNodeDAO.LastModifyTime
              + " is null OR "
              + IProductUITreeNodeDAO.LastModifyTime
              + " = '')");
      return this;
    }

    public Criteria andLastModifyTimeEqualTo(java.util.Date value) {

      addCriterionForJDBCDate(
          IProductUITreeNodeDAO.LastModifyTime + " = ", value, "lastModifyTime");
      return this;
    }

    public Criteria andLastModifyTimeEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyTime);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyTimeEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyTime + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyTimeNotEqualTo(java.util.Date value) {

      addCriterionForJDBCDate(
          IProductUITreeNodeDAO.LastModifyTime + " <>", value, "lastModifyTime");
      return this;
    }

    public Criteria andLastModifyTimeNotEqualToOrIsNull(java.util.Date value) {

      addCriterionForJDBCDate(
          IProductUITreeNodeDAO.LastModifyTime
              + " is null OR "
              + IProductUITreeNodeDAO.LastModifyTime
              + " <>",
          value,
          "lastModifyTime");
      return this;
    }

    public Criteria andLastModifyTimeNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyTime);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyTimeNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyTime + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyTimeGreaterThan(java.util.Date value) {

      addCriterionForJDBCDate(IProductUITreeNodeDAO.LastModifyTime + " >", value, "lastModifyTime");
      return this;
    }

    public Criteria andLastModifyTimeGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyTime);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyTimeGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyTime + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyTimeGreaterThanOrEqualTo(java.util.Date value) {

      addCriterionForJDBCDate(
          IProductUITreeNodeDAO.LastModifyTime + " >=", value, "lastModifyTime");
      return this;
    }

    public Criteria andLastModifyTimeGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyTime);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyTimeGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyTime + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyTimeLessThan(java.util.Date value) {

      addCriterionForJDBCDate(IProductUITreeNodeDAO.LastModifyTime + " <", value, "lastModifyTime");
      return this;
    }

    public Criteria andLastModifyTimeLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyTime);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyTimeLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyTime + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyTimeLessThanOrEqualTo(java.util.Date value) {

      addCriterionForJDBCDate(
          IProductUITreeNodeDAO.LastModifyTime + " <=", value, "lastModifyTime");
      return this;
    }

    public Criteria andLastModifyTimeLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.LastModifyTime);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andLastModifyTimeLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyTime + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyTimeIn(List<java.util.Date> values) {

      if (values.size() == 1) {
        return andLastModifyTimeEqualTo(values.get(0));
      } else {
        addCriterionForJDBCDate(
            IProductUITreeNodeDAO.LastModifyTime + " in", values, "lastModifyTime");
        return this;
      }
    }

    public Criteria andLastModifyTimeNotIn(List<java.util.Date> values) {
      if (values.size() == 1) {
        return andLastModifyTimeNotEqualTo(values.get(0));
      } else {
        addCriterionForJDBCDate(
            IProductUITreeNodeDAO.LastModifyTime + " not in", values, "lastModifyTime");
        return this;
      }
    }

    public Criteria andLastModifyTimeIn(java.util.Date[] values) {

      if (values.length == 1) {
        return andLastModifyTimeEqualTo(values[0]);
      } else {
        addCriterionForJDBCDate(
            IProductUITreeNodeDAO.LastModifyTime + " in", Arrays.asList(values), "lastModifyTime");
        return this;
      }
    }

    public Criteria andLastModifyTimeNotIn(java.util.Date[] values) {
      if (values.length == 1) {
        return andLastModifyTimeNotEqualTo(values[0]);
      } else {
        addCriterionForJDBCDate(
            IProductUITreeNodeDAO.LastModifyTime + " not in",
            Arrays.asList(values),
            "lastModifyTime");
        return this;
      }
    }

    public Criteria andLastModifyTimeIn(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyTime + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyTimeNotIn(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.LastModifyTime + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andLastModifyTimeBetween(java.util.Date value1, java.util.Date value2) {
      addCriterionForJDBCDate(
          IProductUITreeNodeDAO.LastModifyTime + " between", value1, value2, "lastModifyTime");
      return this;
    }

    public Criteria andLastModifyTimeNotBetween(java.util.Date value1, java.util.Date value2) {
      addCriterionForJDBCDate(
          IProductUITreeNodeDAO.LastModifyTime + " not between", value1, value2, "lastModifyTime");
      return this;
    }

    public Criteria andStatusIsNull() {
      addCriterion(IProductUITreeNodeDAO.Status + " is null");
      return this;
    }

    public Criteria andStatusIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.Status + " is not null");
      return this;
    }

    public Criteria andStatusIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.Status
              + " is not null AND "
              + IProductUITreeNodeDAO.Status
              + " <> ''");
      return this;
    }

    public Criteria andStatusIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeNodeDAO.Status
              + " is null OR "
              + IProductUITreeNodeDAO.Status
              + " = '')");
      return this;
    }

    public Criteria andStatusEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Status + " = ", value, "status");
      return this;
    }

    public Criteria andStatusEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Status);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Status + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusNotEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Status + " <>", value, "status");
      return this;
    }

    public Criteria andStatusNotEqualToOrIsNull(String value) {

      addCriterion(
          IProductUITreeNodeDAO.Status + " is null OR " + IProductUITreeNodeDAO.Status + " <>",
          value,
          "status");
      return this;
    }

    public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Status);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Status + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusGreaterThan(String value) {

      addCriterion(IProductUITreeNodeDAO.Status + " >", value, "status");
      return this;
    }

    public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Status);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Status + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusGreaterThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Status + " >=", value, "status");
      return this;
    }

    public Criteria andStatusGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Status);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Status + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusLessThan(String value) {

      addCriterion(IProductUITreeNodeDAO.Status + " <", value, "status");
      return this;
    }

    public Criteria andStatusLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Status);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Status + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusLessThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Status + " <=", value, "status");
      return this;
    }

    public Criteria andStatusLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Status);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Status + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.Status + " like", buffer.toString(), "status");
      return this;
    }

    public Criteria andStatusNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.Status + " not like", buffer.toString(), "status");
      return this;
    }

    public Criteria andStatusIn(List<String> values) {

      if (values.size() == 1) {
        return andStatusEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Status + " in", values, "status");
        return this;
      }
    }

    public Criteria andStatusNotIn(List<String> values) {
      if (values.size() == 1) {
        return andStatusNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Status + " not in", values, "status");
        return this;
      }
    }

    public Criteria andStatusIn(String[] values) {

      if (values.length == 1) {
        return andStatusEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Status + " in", Arrays.asList(values), "status");
        return this;
      }
    }

    public Criteria andStatusNotIn(String[] values) {
      if (values.length == 1) {
        return andStatusNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Status + " not in", Arrays.asList(values), "status");
        return this;
      }
    }

    public Criteria andStatusIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Status + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Status + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.Status + " between", value1, value2, "status");
      return this;
    }

    public Criteria andStatusNotBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.Status + " not between", value1, value2, "status");
      return this;
    }

    public Criteria andRemarksIsNull() {
      addCriterion(IProductUITreeNodeDAO.Remarks + " is null");
      return this;
    }

    public Criteria andRemarksIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.Remarks + " is not null");
      return this;
    }

    public Criteria andRemarksIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.Remarks
              + " is not null AND "
              + IProductUITreeNodeDAO.Remarks
              + " <> ''");
      return this;
    }

    public Criteria andRemarksIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeNodeDAO.Remarks
              + " is null OR "
              + IProductUITreeNodeDAO.Remarks
              + " = '')");
      return this;
    }

    public Criteria andRemarksEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Remarks + " = ", value, "remarks");
      return this;
    }

    public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Remarks);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Remarks + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andRemarksNotEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Remarks + " <>", value, "remarks");
      return this;
    }

    public Criteria andRemarksNotEqualToOrIsNull(String value) {

      addCriterion(
          IProductUITreeNodeDAO.Remarks + " is null OR " + IProductUITreeNodeDAO.Remarks + " <>",
          value,
          "remarks");
      return this;
    }

    public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Remarks);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andRemarksNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Remarks + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andRemarksGreaterThan(String value) {

      addCriterion(IProductUITreeNodeDAO.Remarks + " >", value, "remarks");
      return this;
    }

    public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Remarks);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andRemarksGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Remarks + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andRemarksGreaterThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Remarks + " >=", value, "remarks");
      return this;
    }

    public Criteria andRemarksGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Remarks);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andRemarksGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Remarks + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andRemarksLessThan(String value) {

      addCriterion(IProductUITreeNodeDAO.Remarks + " <", value, "remarks");
      return this;
    }

    public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Remarks);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andRemarksLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Remarks + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andRemarksLessThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.Remarks + " <=", value, "remarks");
      return this;
    }

    public Criteria andRemarksLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.Remarks);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andRemarksLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Remarks + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andRemarksLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.Remarks + " like", buffer.toString(), "remarks");
      return this;
    }

    public Criteria andRemarksNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.Remarks + " not like", buffer.toString(), "remarks");
      return this;
    }

    public Criteria andRemarksIn(List<String> values) {

      if (values.size() == 1) {
        return andRemarksEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Remarks + " in", values, "remarks");
        return this;
      }
    }

    public Criteria andRemarksNotIn(List<String> values) {
      if (values.size() == 1) {
        return andRemarksNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.Remarks + " not in", values, "remarks");
        return this;
      }
    }

    public Criteria andRemarksIn(String[] values) {

      if (values.length == 1) {
        return andRemarksEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Remarks + " in", Arrays.asList(values), "remarks");
        return this;
      }
    }

    public Criteria andRemarksNotIn(String[] values) {
      if (values.length == 1) {
        return andRemarksNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.Remarks + " not in", Arrays.asList(values), "remarks");
        return this;
      }
    }

    public Criteria andRemarksIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Remarks + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andRemarksNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.Remarks + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andRemarksBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.Remarks + " between", value1, value2, "remarks");
      return this;
    }

    public Criteria andRemarksNotBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.Remarks + " not between", value1, value2, "remarks");
      return this;
    }

    public Criteria andIsRootIsNull() {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " is null");
      return this;
    }

    public Criteria andIsRootIsNotNull() {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " is not null");
      return this;
    }

    public Criteria andIsRootIsNotEmpty() {
      addCriterion(
          IProductUITreeNodeDAO.IsRoot
              + " is not null AND "
              + IProductUITreeNodeDAO.IsRoot
              + " <> ''");
      return this;
    }

    public Criteria andIsRootIsEmpty() {
      addCriterion(
          "("
              + IProductUITreeNodeDAO.IsRoot
              + " is null OR "
              + IProductUITreeNodeDAO.IsRoot
              + " = '')");
      return this;
    }

    public Criteria andIsRootEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.IsRoot + " = ", value, "isRoot");
      return this;
    }

    public Criteria andIsRootEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsRoot);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsRootEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsRootNotEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.IsRoot + " <>", value, "isRoot");
      return this;
    }

    public Criteria andIsRootNotEqualToOrIsNull(String value) {

      addCriterion(
          IProductUITreeNodeDAO.IsRoot + " is null OR " + IProductUITreeNodeDAO.IsRoot + " <>",
          value,
          "isRoot");
      return this;
    }

    public Criteria andIsRootNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsRoot);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsRootNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsRootGreaterThan(String value) {

      addCriterion(IProductUITreeNodeDAO.IsRoot + " >", value, "isRoot");
      return this;
    }

    public Criteria andIsRootGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsRoot);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsRootGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsRootGreaterThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.IsRoot + " >=", value, "isRoot");
      return this;
    }

    public Criteria andIsRootGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsRoot);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsRootGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsRootLessThan(String value) {

      addCriterion(IProductUITreeNodeDAO.IsRoot + " <", value, "isRoot");
      return this;
    }

    public Criteria andIsRootLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsRoot);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsRootLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsRootLessThanOrEqualTo(String value) {

      addCriterion(IProductUITreeNodeDAO.IsRoot + " <=", value, "isRoot");
      return this;
    }

    public Criteria andIsRootLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProductUITreeNodeDAO.IsRoot);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIsRootLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsRootLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.IsRoot + " like", buffer.toString(), "isRoot");
      return this;
    }

    public Criteria andIsRootNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProductUITreeNodeDAO.IsRoot + " not like", buffer.toString(), "isRoot");
      return this;
    }

    public Criteria andIsRootIn(List<String> values) {

      if (values.size() == 1) {
        return andIsRootEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.IsRoot + " in", values, "isRoot");
        return this;
      }
    }

    public Criteria andIsRootNotIn(List<String> values) {
      if (values.size() == 1) {
        return andIsRootNotEqualTo(values.get(0));
      } else {
        addCriterion(IProductUITreeNodeDAO.IsRoot + " not in", values, "isRoot");
        return this;
      }
    }

    public Criteria andIsRootIn(String[] values) {

      if (values.length == 1) {
        return andIsRootEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.IsRoot + " in", Arrays.asList(values), "isRoot");
        return this;
      }
    }

    public Criteria andIsRootNotIn(String[] values) {
      if (values.length == 1) {
        return andIsRootNotEqualTo(values[0]);
      } else {
        addCriterion(IProductUITreeNodeDAO.IsRoot + " not in", Arrays.asList(values), "isRoot");
        return this;
      }
    }

    public Criteria andIsRootIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsRootNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIsRootBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " between", value1, value2, "isRoot");
      return this;
    }

    public Criteria andIsRootNotBetween(String value1, String value2) {
      addCriterion(IProductUITreeNodeDAO.IsRoot + " not between", value1, value2, "isRoot");
      return this;
    }
  }
}
